Calc methods

Employee sheet

For instructions on using this sheet, click here.

Calc Method	Type	Description
JobCode	Interface	Sets up initial JobCode block on the Employee tab during the interface process. Do no use when adding blocks to the JobCode tab.
AvgPerPaidHr	Interface	Calculates other Non-FTE related pay based on the relationship to paid hours in the JobCode block. Monthly spread will be based on the spread of paid hours.
AvgPerProdHr	Interface	Calculates other Non-FTE related pay based on the relationship to productive hours in the JobCode block. Monthly spread will be based on the spread of productive hours.
Dept_AvgPerProdHr	Interface	Calculates other Non-FTE related pay based on the relationship to productive hours in the department. Monthly spread will be based on the spread of productive hours. Only use this calc method to budget labor dollars at a department level and not a JobCode level.
Dept_InputMonthly	Interface	Calculates other Non-FTE related pay by inputting monthly amounts for the department. Only use this calc method to budget labor dollars at a department level and not a JobCode level.
Dept_InputTotal	Interface	Calculates other Non-FTE related pay by typing in a total for the department. Monthly spread will be spread evenly by month. Only use this calc method to budget labor dollars at a department level and not a JobCode level.
Employee	Interface	Inserts a new employee into a JobCode block. You can input FTEs and hourly rate. The default hourly rate comes from Mid Rate column in the Budget Labor Limits driverBudget Labor Limits driver.
Holiday	Interface	Calculate salary dollars based on YTD holiday pay and spreads by the listed holiday months in the Budget Labor Configuration driverBudget Labor Configuration driver.
Input_Monthly	Interface	Calculates other Non-FTE related pay by typing in the monthly totals. Add New JobCode 22 Lines New Sets up a new JobCode block on the Employee tab. This calc method allows you to enter FTEs and hourly rate for each labor category.
Add New AvgPer Paid Hr PayType	New	Calculates other Non-FTE related pay based on the relationship to paid hours in the JobCode block. Monthly spread will be based on the spread of paid hours. This calc method is only used when adding a new pay type.
Add New AvgPer Prod Hr PayType	New	Calculates other Non-FTE related pay based on the relationship to productive hours in the JobCode block. Monthly spread will be based on the spread of productive hours. This calc method is only used when adding a new pay type.
Add New Input Monthly PayType	New	Calculates other Non-FTE related pay by typing in the monthly totals. This calc method is only used when adding a new paytype.

Expense sheet

For instructions on using this sheet, click here.

Calc Method	Type	Description
Depreciation	Interface	Pushes depreciation calculations to the budget plan file from List Driver file, Budget Expense Assumptions. The end-user cannot change the totals or the spread in the budget plan files. Only users with administrative rights can update the calculations.
Detail	Interface	Zero-based expense calculations. Inputs are done on the Expense tab in the budget plan file.
FICA	Interface	Transfers FICA expense from the designated labor tab (JobCode, Staffing, Employee, Provider) to the Expense tab.
Fixed_Days	Interface	Allows changes to the projected year as well as budget. This calc method uses calendar days as its default spread option. Users choose the monthly spread from the drop-down.
Fixed_Even	Interface	Allows changes to the projected year as well as budget. This calc method uses an even monthly spread as its default spread option. Users choose the monthly spread from the drop-down.
Fixed_History	Interface	Allows changes to the projected year as well as budget. This calc method uses history as its default spread option. Users choose the monthly spread from the drop-down.
Fixed_Stats	Interface	Interface Allows changes to the projected year as well as budget. This calc method uses the key statistic monthly spread as its default spread option. Users choose the monthly spread from the drop-down.
Fixed_WorkDays	Interface	Allows changes to the projected year as well as budget. This calc method uses worked days as its default spread option. Users choose the monthly spread from the drop-down.
GlobalAmt	Interface	Pushes expense calculations to the budget plan file from List Driver file, Budget Expense Assumptions. An end-user cannot change the totals or the spread in the Budget Plan files. Only users with administrative rights can update the calculations.
GlobalExpense	Interface	Pushes expense calculations to the budget plan file from List Driver file, Budget Expense Assumptions. An end-user cannot change the totals or the spread in the Budget Plan files. Only users with administrative rights can update the calculations.
Hours	Interface	Transfers hours from the designated labor tab (JobCode, Staffing, Employee, Provider) to the expense tab.
InputMonthly	Interface	Month-by-month input.
Labor	Interface	Transfers salary dollars from the designated labor tab (JobCode, Staffing, Employee, Provider) to the Expense tab.
NoBudget	Interface	Brings in historical values into the budget plan file, but the budget for next year will be zero, and cannot be changed.
GlobalData	Interface	This calc method allows the administrator to create configurable budget relationships for calculating NYB amounts for the Expense tab only. The GlobalData calc method is similar to GlobalExpense but allows you to use up to four configurable tabs in Global Data Assumptions. Has to be setup in the Global Data Assumptions Driver file.
PctofGrossRevenue	Interface	Uses the historical percentage of the account to gross revenue from the Stat_Rev tab.
PctofSalaries_Rolling12	Interface	Calculates based on the relationship to salaries using Rolling12 instead of YTD. Monthly spread will be based on the spread of salaries.
PctofNetRevenue	Interface	Calculates based on the relationship to net revenue. Monthly spread will be based on the spread of net revenue.
GlobalSum	Interface	This calc method allows you to budget for an account at a percentage of the total of specific other account(s) on the Stat_Rev tab within the same plan file.
PctofSalaries	Interface	Calculates based on the relationship to salaries. Monthly spread will be based on the spread of salaries.
PctofSalaries _FixedPct	Interface	Calculates a designated fixed percent from List Driver file, Budget Expense Assumptions, based on the relationship to salaries. Monthly spread will be based on the spread of salaries.
RatePerFTE	Interface	Calculates based on the relationship to FTEs. Monthly spread will be based on the spread of FTEs.
RatePerFTE_Fixed	Interface	Allows you to define the fixed dollar amount in List Driver file, Budget Expense Assumptions.per FTE to apply globally to benefit accounts.
Variable	Interface	Calculates based on the relationship to key statistics. A dollars-per-key statistic rate is calculated based on YTD history, and is used to calculate the projection and budget.
Variable_Stat	Interface	Calculates based on the relationship to a user-chosen statistic that is listed on the Stat_Rev tab. A dollars-per-key statistic rate is calculated based on YTD history, and is used to calculate the projection and budget.
Add New Detail	New	Zero-based expense calculations. Inputs are done on the Detail sheet in the budget plan file.
Add New Fixed	New	Allows changes to the projected year as well as budget. Monthly spread is chosen by the user from a drop down box selection. Choose the spread methodology from the drop-down. This Calc Method is only used when adding a new account.
Add New Input Monthly	New	Month-by-month input. Use this calc method only when adding a new account.
Add New Variable	New	Calculates based on the relationship to key statistics. A dollars-per-key statistic rate is calculated based on YTD history, and is used to calculate the projection and budget. This calc method is only used when adding a new account.
Add New Labor	New	Use this new labor calc method to add a new labor account to the Expense sheet.
Add New Hours	New	Use this new labor calc method to add a new hours account to the Expense sheet.

Provider Version Only

If your organization purchased the Provider module license, you have access to the following additional calc methods:

Calc Method	Type	Description
ProviderComp	Interface	Transfers Salary calculations from the ProviderComp sheet to the Expense sheet to save in the Financial Data Tables.
ProviderLaborComp	Interface	Transfers Salary calculations from the ProviderComp and designated labor sheet (JobCode, Staffing, Employee) sheet to the Expense sheet to save in the Financial Data Tables.
ProviderCompFICA	Interface	Transfers FICA calculations from the ProviderComp sheet to the Expense sheet to save in the Financial Data Tables.
ProviderLaborFICA	Interface	Transfers FICA calculations from the ProviderComp and designated labor sheet (JobCode, Staffing, Employee) sheet to the Expense sheet to save in the Financial Data Tables.
ProviderCompHours	Interface	Transfers Hours calculations from the ProviderComp sheet to the Expense sheet to save in the Financial Data Tables.
ProviderLaborHours	Interface	Transfers Hours calculations from the ProviderComp and designated labor sheet (JobCode, Staffing, Employee) sheet to the Expense sheet to save in the Financial Data Tables.
ProviderCompOther	Interface	Transfers other labor calculations from the ProviderComp sheet to the Expense sheet to be saved in the Financial Data Tables.
Add New ProviderLaborComp	New	Use this new labor calc method to add a new labor account to the Expense sheet for Providers.
Add New ProviderLaborHours	New	Use this new labor calc method when necessary to add a new hours account to the Expense sheet for Providers.

JobCode sheet

For instructions on using this sheet, click here.

Calc Method	Type	Description
JobCode	Interface	Sets up initial JobCode block on the JobCode sheet during the interface process. Do not use when adding blocks to the JobCode tab.
AvgPerPaidHr	Interface	Calculates other Non-FTE related pay based on the relationship to paid hours in the JobCode block. Monthly spread will be based on the spread of paid hours.
AvgPerProdHr	Interface	Calculates other Non-FTE related pay based on the relationship to productive hours in the JobCode block. Monthly spread will be based on the spread of productive hours.
Dept_AvgPerProdHr	Interface	Calculates other Non-FTE related pay based on the relationship to productive hours in the department. Monthly spread will be based on the spread of productive hours. Only use this calc method to budget labor dollars at a department level and not a JobCode level.
Dept_InputMonthly	Interface	Calculates other Non-FTE related pay by inputting monthly amounts for the department. Only use this calc method to budget labor dollars at a department level and not a JobCode level.
Dept_InputTotal	Interface	Calculates other Non-FTE related pay by typing in a total for the department. Monthly spread will be spread evenly by month. Only use this calc method to budget labor dollars at a department level and not a JobCode level.
Holiday	Interface	Calculates salary dollars based on YTD holiday pay and spreads by the listed holiday months in the Budget Labor Configuration driverBudget Labor Configuration driver.
Input_Monthly	Interface	Calculate other Non-FTE related pay by typing in the monthly totals.
Add New JobCode	New	Sets up a new JobCode block on the JobCode sheet. This calc method allows the input of FTEs and hourly rate for each labor category. The default hourly rate comes from the Mid Rate column in the Budget Labor Limits driverBudget Labor Limits driver.
Add New AvgPer Paid Hr PayType	New	Calculate other Non-FTE related pay based on the relationship to paid hours in the JobCode block. Monthly spread will be based on the spread of paid hours. This calc method is only used when adding a new pay type.
Add New AvgPer Prod Hr PayType	New	Calculates other Non-FTE related pay based on the relationship to productive hours in the JobCode block. Monthly spread will be based on the spread of productive hours. This calc method is only used when adding a new pay type.
Add New Input Monthly PayType	New	Calculates other Non-FTE related pay by typing in the monthly totals. This calc method is only used when adding a new paytype.

Provider sheet

For instructions on using this sheet, click here.

Calc Method	Type	Description
FinancialClass	Interface	Inserts financial class data to use during the initial interface process.
Provider	Interface	Sets up the Provider Block to use during the initial interface process.
Revenue	Interface	Inserts revenue data to use during the initial interface process to insert revenue data.
RVU	Interface	Inserts RVU data to use during the initial interface process.
Statistic	Interface	Inserts Procedure/Statistic data to use during the initial interface process.
WRVU	Interface	Inserts WRVU data to use during the initial interface process.
Add New Encounter	New	Inserts additional Encounter/Visit lines, if needed, after the initial interface is complete.
Add New FinancialClass	New	Inserts additional Financial Class lines, if needed, after the initial interface is complete.
Add New Procedure	New	Inserts additional Procedure lines, if needed, after the initial interface is complete.
Add New Provider	New	Inserts a new Provider Block.
Add New Revenue	New	Inserts additional Revenue lines, if needed, after the initial interface is complete.
Add New RVU	New	Inserts additional RVU lines, if needed, after the initial interface is complete.
Add New WRVU	New	Inserts additional WRVU lines, if needed, after the initial interface is complete.
Copy From Existing Provider	New	Inserts a new Provider Block and allows the statistical history from an existing Provider to copy into the new Provider block.

Staffing sheet

For instructions on using this sheet, click here.

Calc Method	Type	Description
JobCode	Interface	Sets up initial JobCode block on the Staffing tab during the interface process. Do not use when adding blocks to the Staffing tab.
AvgPerPaidHr	Interface	Calculates other Non-FTE related pay based on the relationship to paid hours in the JobCode block. Monthly spread will be based on the spread of paid hours.
AvgPerProdHr	Interface	Calculates other Non-FTE related pay based on the relationship to productive hours in the JobCode block. Monthly spread will be based on the spread of productive hours.
DeptAvgPerPaidHr	Interface	Calculate other Non-FTE related pay based on the relationship to paid hours in the department. Monthly spread will be based on the spread of paid hours. Only use this calc method to budget labor dollars at a department level and not a JobCode level.
Dept_InputMonthly	Interface	Calculates other Non-FTE related pay by inputting monthly amounts for the department. Only use this calc methid to budget labor dollars at a department level and not a JobCode level.
Dept_InputTotal	Interface	Calculates other Non-FTE related pay by typing in a total for the department. Monthly spread will be spread evenly by month. Only use this calc method to budget labor dollars at a department level and not a JobCode level.
Holiday	Interface	Calculates salary dollars based on YTD holiday pay and spreads by the listed holiday months in the Budget Labor Configuration driverBudget Labor Configuration driver.
Input_Monthly	Interface	Calculates other Non-FTE related pay by typing in the monthly totals.
Input_Total	Interface	Calculates other Non-FTE related pay by typing in the total dollars. The monthly spread will be spread evenly.
Add New JobCode	New	Sets up a new JobCode block on the Staffing tab. This calc method allows the input of FTEs and hourly rate for each labor category. The default hourly rate comes from the Mid Rate column in the Budget Labor Limits driverBudget Labor Limits driver.
Add New Input Monthly PayType	New	Calculates other Non-FTE related pay by typing in the monthly totals. This Calc Method is only used when adding a new pay type.
Add New Input Total PayType	New	Calculates other Non-FTE related pay by typing in the total dollars. The monthly spread will be even. This calc method is only used when adding a new pay type. The FTEs from Target should have no variance for a budget to be acceptable.

Stat_Rev (Statistics and Revenue) sheet

For instructions on using this sheet, click here.

Calc Method	Description
Allowance	Calculate deductions based on a percentage of gross revenue.
BadDebt	Calculate bad debt based on a percentage of gross revenue.
Detail	Zeros base revenue calculations.
FixedRevenue	Allows changes to the projected year as well as budget. Usually used for other operating revenue accounts. Select the monthly spread from the drop-down.
GlobalRevenue	Pushes revenue or deduction calculations to the budget plan file from Budget Assumptions. End users cannot change the totals or the spread in the budget plan files. Only users with administrative rights can update the calculations.
GlobalSum	This SPM allows you to budget for an account at a percentage of the total of specific other account(s) on the Stat_Rev tab within the same workbook.
InputMonthly	Month by month input.
IP_Per_Unit	This revenue calc method is now an independent calculation of IP revenue by account using the historical revenue per unit.
IP_Payor	Calculates the total IP revenue, and then allocates it based on the historical percentages by payor. Only use this calc method if the GL gross revenue account structure is by payor.
OP_Per_Unit	This revenue calc method is now an independent calculation of OP revenue by account using the historical revenue per unit.
OP_Payor	This calc method calculates the total IP revenue, and then allocates it based on the historical percentages by payor. Use this calc method only if the GL gross revenue account structure is by payor.
Oth_Per_Unit	This revenue calc method is now an independent calculation of Other Patient revenue by account using the historical revenue per unit.
Oth_Payor	This calc method calculates the total IP revenue, and then allocates it based on the historical percentages by payor. Only use this calc method if the GL gross revenue account structure is by payor.
NoBudget	Brings in historical values into the budget plan file, but the budget for next year will be zero, and cannot be changed.
Statistic	Calculates projected and budget key statistics.
Statistic_Oth	Calculates projected and budget non-key statistics based on their relationship to the key statistic.
Revenue_Stat	This revenue calc method allows you to define the statistic account from the Stat_Rev tab to use as the basis of the per unit calculation and the multiplier for the budget. For example, there my be an Other Department statistic in the OR for implant cases that should be used to drive the Revenue-Implant account.
Add New Detail	Zero-based expense calculations when adding a new account. Inputs are done on the Detail tab in the budget plan file.
Add New Fixed Revenue	Use this new revenue calc method to add a new Fixed Revenue account to the Stat_Rev tab.
Add New Input Monthly	Use this new revenue or statistic calc method to add a new account to the Stat_Rev tab.
Add New Statistic	Use this new statistic calc method to add a new key statistic account to the Stat_Rev tab.
Add New Statistic_Oth	Use this new statistic calc method to add a new Other Statistic account to the Stat_Rev tab.

Provider Version Only

If your organization purchased the Provider module license, you have access to the following additional calc methods:

Calc Method	Description
ProviderRev	Transfers Revenue calculations from the Provider Summary/Provider Detail tab to the Stat_Rev tab to save to the Financial Data tables.
ProviderStat	Transfers Statistic calculations from the Provider Summary/Provider Detail tab to the Stat_Rev tab to save to the Financial Data tables.
ProviderComp	Transfers Salary calculations from the Provider tab to the Stat_Rev tab to save to the Financial Data tables. NOTE: Provider Light Version Only: Calc Methods – Stat_Rev Sheet If your organization has purchased the Provider module, you can access the following additional calc methods if using the Provider Light. Provider_Simple_Rev – Transfers Revenue calculations from the Provider Simple Rev tab to the Stat_Rev tab to save to the Financial Data Tables. If your GL structure has multiple revenue accounts for Provider revenue, then apply the calculation method Provider_Simple_Rev to each revenue account. Provider_Simple_Stat – Transfers Statistic calculations from the Provider Simple Rev tab to the Stat_Rev tab to save to the Financial Data Tables. Assign this to the key statistic you are using as your driver stat on the Provider tab. For example, when using WRVU as your Driver stat, add Provider_Simple_Stat to the GL acct on the ACCT dimension table for WRVUs.

Calc Method

Description

ProviderRev

Transfers Revenue calculations from the Provider Summary/Provider Detail tab to the Stat_Rev tab to save to the Financial Data tables.

ProviderStat

Transfers Statistic calculations from the Provider Summary/Provider Detail tab to the Stat_Rev tab to save to the Financial Data tables.

ProviderComp

Transfers Salary calculations from the Provider tab to the Stat_Rev tab to save to the Financial Data tables.

NOTE: Provider Light Version Only: Calc Methods – Stat_Rev Sheet

If your organization has purchased the Provider module, you can access the following additional calc methods if using the Provider Light.

Provider_Simple_Rev – Transfers Revenue calculations from the Provider Simple Rev tab to the Stat_Rev tab to save to the Financial Data Tables. If your GL structure has multiple revenue accounts for Provider revenue, then apply the calculation method Provider_Simple_Rev to each revenue account.
Provider_Simple_Stat – Transfers Statistic calculations from the Provider Simple Rev tab to the Stat_Rev tab to save to the Financial Data Tables. Assign this to the key statistic you are using as your driver stat on the Provider tab. For example, when using WRVU as your Driver stat, add Provider_Simple_Stat to the GL acct on the ACCT dimension table for WRVUs.